<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_back_order`;");
E_C("CREATE TABLE `ecs_back_order` (
  `back_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_sn` varchar(20) NOT NULL,
  `order_sn` varchar(20) NOT NULL,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `invoice_no` varchar(50) DEFAULT NULL,
  `add_time` int(10) unsigned DEFAULT '0',
  `shipping_id` tinyint(3) unsigned DEFAULT '0',
  `shipping_name` varchar(120) DEFAULT NULL,
  `user_id` mediumint(8) unsigned DEFAULT '0',
  `action_user` varchar(30) DEFAULT NULL,
  `consignee` varchar(60) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `country` smallint(5) unsigned DEFAULT '0',
  `province` smallint(5) unsigned DEFAULT '0',
  `city` smallint(5) unsigned DEFAULT '0',
  `district` smallint(5) unsigned DEFAULT '0',
  `sign_building` varchar(120) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `zipcode` varchar(60) DEFAULT NULL,
  `tel` varchar(60) DEFAULT NULL,
  `mobile` varchar(60) DEFAULT NULL,
  `best_time` varchar(120) DEFAULT NULL,
  `postscript` varchar(255) DEFAULT NULL,
  `how_oos` varchar(120) DEFAULT NULL,
  `insure_fee` decimal(10,2) unsigned DEFAULT '0.00',
  `shipping_fee` decimal(10,2) unsigned DEFAULT '0.00',
  `update_time` int(10) unsigned DEFAULT '0',
  `suppliers_id` smallint(5) DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `return_time` int(10) unsigned DEFAULT '0',
  `agency_id` smallint(5) unsigned DEFAULT '0',
  `refund_type` tinyint(1) NOT NULL DEFAULT '0',
  `refund_desc` varchar(255) NOT NULL,
  `refund_money_1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `refund_money_2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `back_reason` varchar(255) NOT NULL DEFAULT '',
  `goods_id` int(10) unsigned NOT NULL,
  `goods_name` varchar(255) NOT NULL DEFAULT '',
  `status_back` tinyint(1) NOT NULL DEFAULT '0',
  `status_refund` tinyint(1) NOT NULL DEFAULT '0',
  `imgs` text NOT NULL,
  `back_pay` tinyint(1) NOT NULL DEFAULT '0',
  `back_type` varchar(1) NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`back_id`),
  KEY `user_id` (`user_id`),
  KEY `order_id` (`order_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_back_order` values('11','','2014091803869','3','668896279127','1411093785','1','申通快递','13','','李女士','A街303号','1','2','52','500','','','01012345','','18712345678','','','','0.00','0.00','0','0','0','0','0','0','','0.00','0.00','商品有瑕疵','157','玻璃纱拼接设计无袖高领裙','0','9','/images/image/201409/20140919102929_18248.jpg','2','2','2');");
E_D("replace into `ecs_back_order` values('12','','2014091899507','1','668896279127','1411093929','1','申通快递','13','','李女士','A街303号','1','2','52','500','','','','','18712345678','','我要退货','','0.00','0.00','0','0','0','0','0','0','','433.00','0.00','不喜欢，我要退货','104','[麦包包(M Plus)]复古范系列双肩多功能包','3','0','/images/image/201409/20140919103156_67302.jpg','1','1','0');");
E_D("replace into `ecs_back_order` values('13','','2014120597757','2',NULL,'1417760793','0',NULL,'39',NULL,'用户1','某街道122号','1','10','145','1195',NULL,NULL,'',NULL,'13333333333',NULL,'',NULL,'0.00','15.00','0','0','0','0','0','2','','67.00','67.00','退货退货','102','[浪美]LIFE MATCH 乐活系列手提双肩背包','3','1','','2','1','0');");
E_D("replace into `ecs_back_order` values('14','','2014120527272','1','11111111111111','1417761914','1','申通快递','39',NULL,'用户1','某街道122号','1','10','145','1195',NULL,NULL,'',NULL,'13333333333',NULL,'',NULL,'0.00','5.00','0','0','0','0','0','0','','299.00','0.00','退货2014120527272 	[希夏邦马]hello BUGS系列单肩包','111','[希夏邦马]hello BUGS系列单肩包','3','0','','1','1','0');");
E_D("replace into `ecs_back_order` values('15','','2014120565245','6',NULL,'1417763894','0',NULL,'39',NULL,'用户1','某街道122号','1','10','145','1195',NULL,NULL,'11111111',NULL,'13333333333',NULL,'',NULL,'0.00','15.00','0','0','0','0','0','0','','0.00','0.00','换货','63','[戈尔本] 锐·风尚系列全粒面牛皮休闲斜挎包','2','9','','2','2','0');");
E_D("replace into `ecs_back_order` values('16','','2014120571955','9','9999999999999','1417765085','1','申通快递','39',NULL,'东城','东城测试','1','2','52','500',NULL,NULL,'11111111',NULL,'13555555555',NULL,'维修',NULL,'0.00','15.00','0','0','0','0','0','0','','0.00','0.00','2014120571955 	[戈尔本]复古回潮系列沙色油蜡头层牛皮手提可斜挎包 维修测试','83','[戈尔本]复古回潮系列沙色油蜡头层牛皮手提可斜挎包','3','9','','2','3','0');");
E_D("replace into `ecs_back_order` values('17','','2014121051571','40',NULL,'1418189741','0',NULL,'42',NULL,'dddde','dededededede','1','10','145','1195',NULL,NULL,'',NULL,'13323234455',NULL,'',NULL,'0.00','0.00','0','0','0','0','0','0','','128.00','0.00','···','56','Milky Moon Cake','0','0','','2','1','0');");
E_D("replace into `ecs_back_order` values('18','','2014121210920','63',NULL,'1418351760','0',NULL,'39',NULL,'北京海淀','海淀测试','1','2','52','502',NULL,NULL,'122222',NULL,'13444444444',NULL,'未确认收货维修',NULL,'0.00','0.00','0','0','0','0','0','0','','0.00','0.00','未确认收货维修','98','[浪美]爱豆系列手提双肩背包','0','9','','2','3','0');");
E_D("replace into `ecs_back_order` values('19','','2014121238831','64','2014121238831','1418352032','1','申通快递','44',NULL,'王女士','A街道B区','1','2','52','500',NULL,NULL,'',NULL,'13434135143',NULL,'请退款',NULL,'0.00','0.00','0','0','0','0','0','2','','322.00','322.00','质量不合格','100','[DELSEY]四轮纤巧登机拉杆箱20寸','3','1','/images/image/201412/20141212023925_31390.jpg','2','1','0');");

require("../../inc/footer.php");
?>